-- primero borrar [Canasta].[DetalleTransaccion]

USE [EstacionNSX]
GO

/****** Object:  Table [Canasta].[DetalleTransaccion]    Script Date: 29/08/2018 04:25:59 p.m. ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [Canasta].[DetalleTransaccion](
	[Pk_IdCanastaDetalleTransaccion] [int] IDENTITY(1,1) NOT NULL,
	[Cantidad] [float] NOT NULL,
	[TotalRegistrado] [float] NOT NULL,
	[Impuesto] [float] NOT NULL,
	[Base] [float] NOT NULL,
	[Fk_IdTransaccion] [int] NULL,
	[Fk_IdProductoCanasta] [int] NULL,
 CONSTRAINT [PK_DetalleTransaccion] PRIMARY KEY CLUSTERED 
(
	[Pk_IdCanastaDetalleTransaccion] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [Canasta].[DetalleTransaccion]  WITH CHECK ADD  CONSTRAINT [FK_DetalleTransaccion_ProductoCanasta] FOREIGN KEY([Fk_IdProductoCanasta])
REFERENCES [Canasta].[ProductoCanasta] ([Pk_IdProducto])
GO

ALTER TABLE [Canasta].[DetalleTransaccion] CHECK CONSTRAINT [FK_DetalleTransaccion_ProductoCanasta]
GO

ALTER TABLE [Canasta].[DetalleTransaccion]  WITH CHECK ADD  CONSTRAINT [FK_DetalleTransaccion_Transaccion] FOREIGN KEY([Fk_IdTransaccion])
REFERENCES [Canasta].[Transaccion] ([Pk_IdCanastaTransaccion])
GO

ALTER TABLE [Canasta].[DetalleTransaccion] CHECK CONSTRAINT [FK_DetalleTransaccion_Transaccion]
GO


